Pandas Profiling Report

Dataset statistics

Number of variables	23
Number of observations	3272774
Missing cells	8510964
Missing cells (%)	11.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	574.3 MiB
Average record size in memory	184.0 B

Variable types

Numeric	13
Categorical	10

Alerts

`time` has a high cardinality: 3256632 distinct values	High cardinality
`id` has a high cardinality: 3256955 distinct values	High cardinality
`updated` has a high cardinality: 3124771 distinct values	High cardinality
`place` has a high cardinality: 205436 distinct values	High cardinality
`locationSource` has a high cardinality: 199 distinct values	High cardinality
`magSource` has a high cardinality: 333 distinct values	High cardinality
`latitude` is highly correlated with `longitude`	High correlation
`longitude` is highly correlated with `latitude`	High correlation
`depth` is highly correlated with `rms`	High correlation
`mag` is highly correlated with `rms`	High correlation
`nst` is highly correlated with `horizontalError`	High correlation
`gap` is highly correlated with `horizontalError`	High correlation
`dmin` is highly correlated with `rms`	High correlation
`rms` is highly correlated with `depth` and 2 other fields	High correlation
`horizontalError` is highly correlated with `nst` and 2 other fields	High correlation
`depthError` is highly correlated with `horizontalError`	High correlation
`latitude` is highly correlated with `mag`	High correlation
`longitude` is highly correlated with `mag`	High correlation
`mag` is highly correlated with `latitude` and 2 other fields	High correlation
`nst` is highly correlated with `magNst`	High correlation
`rms` is highly correlated with `mag`	High correlation
`magNst` is highly correlated with `nst`	High correlation
`horizontalError` is highly correlated with `depthError`	High correlation
`depthError` is highly correlated with `horizontalError`	High correlation
`latitude` is highly correlated with `longitude` and 3 other fields	High correlation
`longitude` is highly correlated with `latitude` and 3 other fields	High correlation
`depth` is highly correlated with `latitude`	High correlation
`mag` is highly correlated with `longitude` and 2 other fields	High correlation
`magType` is highly correlated with `latitude` and 4 other fields	High correlation
`nst` is highly correlated with `magType`	High correlation
`net` is highly correlated with `latitude` and 3 other fields	High correlation
`mag` has 156449 (4.8%) missing values	Missing
`magType` has 167407 (5.1%) missing values	Missing
`nst` has 881566 (26.9%) missing values	Missing
`gap` has 838549 (25.6%) missing values	Missing
`dmin` has 1346742 (41.1%) missing values	Missing
`rms` has 211653 (6.5%) missing values	Missing
`horizontalError` has 1531963 (46.8%) missing values	Missing
`depthError` has 606685 (18.5%) missing values	Missing
`magError` has 1781012 (54.4%) missing values	Missing
`magNst` has 988917 (30.2%) missing values	Missing
`rms` is highly skewed (γ1 = 23.86159713)	Skewed
`depthError` is highly skewed (γ1 = 1354.147975)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`time` is uniformly distributed	Uniform
`id` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`depth` has 49534 (1.5%) zeros	Zeros
`nst` has 329596 (10.1%) zeros	Zeros
`depthError` has 68134 (2.1%) zeros	Zeros
`magError` has 35432 (1.1%) zeros	Zeros
`magNst` has 107921 (3.3%) zeros	Zeros

Reproduction

Analysis started	2022-03-14 19:49:20.447952
Analysis finished	2022-03-14 20:00:39.774304
Duration	11 minutes and 19.33 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	3272774
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1636386.5

Minimum	0
Maximum	3272773
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	25.0 MiB

Quantile statistics

Minimum	0
5-th percentile	163638.65
Q1	818193.25
median	1636386.5
Q3	2454579.75
95-th percentile	3109134.35
Maximum	3272773
Range	3272773
Interquartile range (IQR)	1636386.5

Descriptive statistics

Standard deviation	944768.6193
Coefficient of variation (CV)	0.5773505338
Kurtosis	-1.2
Mean	1636386.5
Median Absolute Deviation (MAD)	818193.5
Skewness	-3.0727145 × 10^-17
Sum	5.355523191 × 10¹²
Variance	8.92587744 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
988481	1	< 0.1%
2142562	1	< 0.1%
2142560	1	< 0.1%
2142559	1	< 0.1%
2142558	1	< 0.1%
2142557	1	< 0.1%
2142556	1	< 0.1%
2142555	1	< 0.1%
2142554	1	< 0.1%
2142553	1	< 0.1%
Other values (3272764)	3272764	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
3272773	1	< 0.1%
3272772	1	< 0.1%
3272771	1	< 0.1%
3272770	1	< 0.1%
3272769	1	< 0.1%
3272768	1	< 0.1%
3272767	1	< 0.1%
3272766	1	< 0.1%
3272765	1	< 0.1%
3272764	1	< 0.1%

time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	3256632
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Memory size	25.0 MiB

1970-01-01T00:00:00.0Z	7
2014-03-02T11:31:33.000Z	4
1999-11-30T00:00:00.000Z	3
1986-03-02T18:05:37.900Z	2
1986-03-02T16:52:58.480Z	2
Other values (3256627)	3272756

Length

Max length	24
Median length	24
Mean length	23.99999572
Min length	22

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3240498 ?
Unique (%)	99.0%

Sample

1st row	1970-01-01T00:00:00.0Z
2nd row	1970-01-01T00:00:00.0Z
3rd row	1970-01-01T00:00:00.0Z
4th row	1970-01-01T00:00:00.0Z
5th row	1970-01-01T00:00:00.0Z

Common Values

Value	Count	Frequency (%)
1970-01-01T00:00:00.0Z	7	< 0.1%
2014-03-02T11:31:33.000Z	4	< 0.1%
1999-11-30T00:00:00.000Z	3	< 0.1%
1986-03-02T18:05:37.900Z	2	< 0.1%
1986-03-02T16:52:58.480Z	2	< 0.1%
1986-03-02T16:57:44.390Z	2	< 0.1%
1986-03-02T16:57:58.300Z	2	< 0.1%
1986-03-02T17:00:48.180Z	2	< 0.1%
1986-03-02T17:01:29.620Z	2	< 0.1%
1986-03-02T17:11:02.620Z	2	< 0.1%
Other values (3256622)	3272746	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1970-01-01t00:00:00.0z	7	< 0.1%
2014-03-02t11:31:33.000z	4	< 0.1%
1999-11-30t00:00:00.000z	3	< 0.1%
2005-03-02t06:25:32.970z	2	< 0.1%
2005-03-02t06:04:36.700z	2	< 0.1%
2005-03-02t06:10:13.700z	2	< 0.1%
2005-03-02t06:11:26.820z	2	< 0.1%
2005-03-02t06:13:31.430z	2	< 0.1%
2005-03-02t06:16:24.750z	2	< 0.1%
2005-03-02t06:34:03.210z	2	< 0.1%
Other values (3256622)	3272746	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

latitude
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	419761
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.72073813

Minimum	-84.422
Maximum	87.265
Zeros	10
Zeros (%)	< 0.1%
Negative	250887
Negative (%)	7.7%
Memory size	25.0 MiB

Quantile statistics

Minimum	-84.422
5-th percentile	-13.18035
Q1	34.118
median	37.5761667
Q3	42.2586667
95-th percentile	63.0834
Maximum	87.265
Range	171.687
Interquartile range (IQR)	8.1406667

Descriptive statistics

Standard deviation	20.25672335
Coefficient of variation (CV)	0.5670857998
Kurtosis	4.418748879
Mean	35.72073813
Median Absolute Deviation (MAD)	3.5581667
Skewness	-1.792298533
Sum	116905903
Variance	410.334841
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35.03	2978	0.1%
34.62	2126	0.1%
33.06	1531	< 0.1%
38.8216667	1243	< 0.1%
38.8195	1110	< 0.1%
38.8201667	985	< 0.1%
38.8218333	982	< 0.1%
34.35	969	< 0.1%
38.8146667	954	< 0.1%
38.8198333	949	< 0.1%
Other values (419751)	3258947	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-84.422	1	< 0.1%
-84.133	1	< 0.1%
-83.902	1	< 0.1%
-82.064	1	< 0.1%
-81.17	1	< 0.1%
-80.732	1	< 0.1%
-79.9837	1	< 0.1%
-77.36	1	< 0.1%
-77.134	1	< 0.1%
-77.08	1	< 0.1%

Value	Count	Frequency (%)
87.265	1	< 0.1%
87.221	1	< 0.1%
87.161	1	< 0.1%
87.118	1	< 0.1%
87.092	1	< 0.1%
87.081	1	< 0.1%
87.068	1	< 0.1%
87.051	1	< 0.1%
87.009	1	< 0.1%
87.008	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	610455
Distinct (%)	18.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-92.85667108

Minimum	-179.999
Maximum	180
Zeros	17
Zeros (%)	< 0.1%
Negative	2825927
Negative (%)	86.3%
Memory size	25.0 MiB

Quantile statistics

Minimum	-179.999
5-th percentile	-155.2777
Q1	-122.7958298
median	-118.8111667
Q3	-115.4541667
95-th percentile	130.252
Maximum	180
Range	359.999
Interquartile range (IQR)	7.3416631

Descriptive statistics

Standard deviation	80.55325537
Coefficient of variation (CV)	-0.8675010038
Kurtosis	3.377257838
Mean	-92.85667108
Median Absolute Deviation (MAD)	3.9753333
Skewness	2.10801072
Sum	-303898898.8
Variance	6488.82695
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-117.68	3070	0.1%
-117.3	1542	< 0.1%
-115	1444	< 0.1%
-116.85	886	< 0.1%
-118.28	843	< 0.1%
-122.7963333	818	< 0.1%
-122.8103333	811	< 0.1%
-122.796	726	< 0.1%
-122.7971667	709	< 0.1%
-122.7975	708	< 0.1%
Other values (610445)	3261217	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-179.999	6	< 0.1%
-179.9989	1	< 0.1%
-179.9986	1	< 0.1%
-179.9985	1	< 0.1%
-179.9983	2	< 0.1%
-179.9982	1	< 0.1%
-179.998	3	< 0.1%
-179.9978	1	< 0.1%
-179.9976	1	< 0.1%
-179.9972	1	< 0.1%

Value	Count	Frequency (%)
180	11	< 0.1%
179.9999	1	< 0.1%
179.9993	2	< 0.1%
179.999	11	< 0.1%
179.9988	1	< 0.1%
179.998	9	< 0.1%
179.9979	2	< 0.1%
179.9977	1	< 0.1%
179.9976	2	< 0.1%
179.9975	1	< 0.1%

depth
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	60221
Distinct (%)	1.8%
Missing	9
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	22.33494593

Minimum	-10
Maximum	735.8
Zeros	49534
Zeros (%)	1.5%
Negative	180678
Negative (%)	5.5%
Memory size	25.0 MiB

Quantile statistics

Minimum	-10
5-th percentile	-0.159
Q1	3.002
median	7.155
Q3	15
95-th percentile	100
Maximum	735.8
Range	745.8
Interquartile range (IQR)	11.998

Descriptive statistics

Standard deviation	56.32032848
Coefficient of variation (CV)	2.521623677
Kurtosis	55.47258837
Mean	22.33494593
Median Absolute Deviation (MAD)	4.874
Skewness	6.66499493
Sum	73097029.32
Variance	3171.9794
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	182559	5.6%
33	104344	3.2%
0	49534	1.5%
5	39471	1.2%
35	20224	0.6%
1	16608	0.5%
6	14270	0.4%
15	7076	0.2%
2	6808	0.2%
30	6743	0.2%
Other values (60211)	2825128	86.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-10	2	< 0.1%
-9.9	2	< 0.1%
-6.8	1	< 0.1%
-6.6	1	< 0.1%
-5.6	2	< 0.1%
-5.3	1	< 0.1%
-5.2	1	< 0.1%
-4.9	10	< 0.1%
-4.8	6	< 0.1%
-4.7	1	< 0.1%

Value	Count	Frequency (%)
735.8	1	< 0.1%
728.5	1	< 0.1%
721.8	1	< 0.1%
717	1	< 0.1%
712.5	1	< 0.1%
712.2	1	< 0.1%
709.7	1	< 0.1%
707.9	1	< 0.1%
707.3	1	< 0.1%
700.9	1	< 0.1%

mag
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	751
Distinct (%)	< 0.1%
Missing	156449
Missing (%)	4.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.878940887

Minimum	-9.99
Maximum	9.1
Zeros	22265
Zeros (%)	0.7%
Negative	62366
Negative (%)	1.9%
Memory size	25.0 MiB

Quantile statistics

Minimum	-9.99
5-th percentile	0.26
Q1	0.97
median	1.5
Q3	2.46
95-th percentile	4.6
Maximum	9.1
Range	19.09
Interquartile range (IQR)	1.49

Descriptive statistics

Standard deviation	1.352506451
Coefficient of variation (CV)	0.7198238437
Kurtosis	1.44343478
Mean	1.878940887
Median Absolute Deviation (MAD)	0.66
Skewness	0.7949535801
Sum	5855390.46
Variance	1.829273701
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.4	65660	2.0%
1.3	64188	2.0%
1.1	61198	1.9%
1.2	60503	1.8%
1.5	57333	1.8%
1.6	55779	1.7%
1	52448	1.6%
1.7	47642	1.5%
0.9	46583	1.4%
1.8	44462	1.4%
Other values (741)	2560529	78.2%
(Missing)	156449	4.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-9.99	678	< 0.1%
-5	1	< 0.1%
-3	1	< 0.1%
-2.6	2	< 0.1%
-2.5	4	< 0.1%
-2.2	1	< 0.1%
-2	4	< 0.1%
-1.9	5	< 0.1%
-1.8	5	< 0.1%
-1.76	1	< 0.1%

Value	Count	Frequency (%)
9.1	2	< 0.1%
8.8	1	< 0.1%
8.6	2	< 0.1%
8.4	2	< 0.1%
8.3	6	< 0.1%
8.2	7	< 0.1%
8.1	6	< 0.1%
8	12	< 0.1%
7.9	21	< 0.1%
7.8	27	< 0.1%

magType
Categorical

HIGH CORRELATION
MISSING

Distinct	30
Distinct (%)	< 0.1%
Missing	167407
Missing (%)	5.1%
Memory size	25.0 MiB

md	1137605
ml	1092572
mb	376129
mc	248196
mh	113933
Other values (25)	136932

Length

Max length	7
Median length	2
Mean length	2.024506282
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	mh
2nd row	mh
3rd row	mh
4th row	mh
5th row	mh

Common Values

Value	Count	Frequency (%)
md	1137605	34.8%
ml	1092572	33.4%
mb	376129	11.5%
mc	248196	7.6%
mh	113933	3.5%
Ml	21334	0.7%
mdl	20303	0.6%
mwc	20081	0.6%
Md	17242	0.5%
mw	12187	0.4%
Other values (20)	45785	1.4%
(Missing)	167407	5.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
md	1154847	37.2%
ml	1113906	35.9%
mb	376158	12.1%
mc	248196	8.0%
mh	113933	3.7%
mdl	20303	0.7%
mwc	20081	0.6%
mw	12188	0.4%
mblg	11782	0.4%
m	8506	0.3%
Other values (15)	25467	0.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

nst
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	739
Distinct (%)	< 0.1%
Missing	881566
Missing (%)	26.9%
Infinite	0
Infinite (%)	0.0%
Mean	15.6014964

Minimum	0
Maximum	934
Zeros	329596
Zeros (%)	10.1%
Negative	0
Negative (%)	0.0%
Memory size	25.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	10
Q3	18
95-th percentile	45
Maximum	934
Range	934
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	26.60686592
Coefficient of variation (CV)	1.705404741
Kurtosis	146.7141195
Mean	15.6014964
Median Absolute Deviation (MAD)	5
Skewness	9.603187493
Sum	37306423
Variance	707.9253143
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	329596	10.1%
6	151910	4.6%
7	150554	4.6%
5	140938	4.3%
8	137374	4.2%
9	123345	3.8%
10	109294	3.3%
4	108227	3.3%
11	97062	3.0%
12	85305	2.6%
Other values (729)	957603	29.3%
(Missing)	881566	26.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	329596	10.1%
1	62	< 0.1%
2	1930	0.1%
3	29005	0.9%
4	108227	3.3%
5	140938	4.3%
6	151910	4.6%
7	150554	4.6%
8	137374	4.2%
9	123345	3.8%

Value	Count	Frequency (%)
934	1	< 0.1%
929	1	< 0.1%
918	1	< 0.1%
885	1	< 0.1%
882	1	< 0.1%
862	1	< 0.1%
857	1	< 0.1%
832	1	< 0.1%
821	1	< 0.1%
814	1	< 0.1%

gap
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	30876
Distinct (%)	1.3%
Missing	838549
Missing (%)	25.6%
Infinite	0
Infinite (%)	0.0%
Mean	130.4876076

Minimum	0
Maximum	360
Zeros	13825
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	25.0 MiB

Quantile statistics

Minimum	0
5-th percentile	43.5
Q1	79
median	115
Q3	168.26
95-th percentile	274
Maximum	360
Range	360
Interquartile range (IQR)	89.26

Descriptive statistics

Standard deviation	69.71062107
Coefficient of variation (CV)	0.5342317355
Kurtosis	0.2893891101
Mean	130.4876076
Median Absolute Deviation (MAD)	42
Skewness	0.888355514
Sum	317636196.6
Variance	4859.57069
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13825	0.4%
100	13496	0.4%
77	13314	0.4%
76	13250	0.4%
98	13160	0.4%
75	13147	0.4%
74	13131	0.4%
78	13121	0.4%
72	13032	0.4%
80	12998	0.4%
Other values (30866)	2301751	70.3%
(Missing)	838549	25.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13825	0.4%
6.5	1	< 0.1%
7	2	< 0.1%
8	4	< 0.1%
8.4	1	< 0.1%
8.5	1	< 0.1%
8.6	1	< 0.1%
8.7	1	< 0.1%
9	11	< 0.1%
9.3	1	< 0.1%

Value	Count	Frequency (%)
360	661	< 0.1%
359.9	14	< 0.1%
359.8	13	< 0.1%
359.7	7	< 0.1%
359.6	6	< 0.1%
359.5	4	< 0.1%
359.3	3	< 0.1%
359.2	1	< 0.1%
359.1	2	< 0.1%
359	66	< 0.1%

dmin
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	43434
Distinct (%)	2.3%
Missing	1346742
Missing (%)	41.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.2559989956

Minimum	0
Maximum	141.16
Zeros	785
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	25.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0.006306
Q1	0.02093
median	0.05135
Q3	0.116
95-th percentile	0.739245
Maximum	141.16
Range	141.16
Interquartile range (IQR)	0.09507

Descriptive statistics

Standard deviation	1.333459187
Coefficient of variation (CV)	5.208845383
Kurtosis	680.1915783
Mean	0.2559989956
Median Absolute Deviation (MAD)	0.03694
Skewness	19.22444355
Sum	493062.2576
Variance	1.778113402
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.00991	21373	0.7%
0.01081	20984	0.6%
0.009009	20297	0.6%
0.01171	20159	0.6%
0.01261	20028	0.6%
0.01351	18703	0.6%
0.008108	18662	0.6%
0.01441	18091	0.6%
0.01532	17525	0.5%
0.007207	17048	0.5%
Other values (43424)	1733162	53.0%
(Missing)	1346742	41.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	785	< 0.1%
0.0001066	1	< 0.1%
0.0001212	1	< 0.1%
0.0001257	1	< 0.1%
0.0001281	1	< 0.1%
0.0001293	6	< 0.1%
0.0001317	3	< 0.1%
0.0001325	1	< 0.1%
0.0001412	1	< 0.1%
0.0001414	1	< 0.1%

Value	Count	Frequency (%)
141.16	1	< 0.1%
134.43	1	< 0.1%
127.42	1	< 0.1%
122.81	1	< 0.1%
114.61	1	< 0.1%
111.5	1	< 0.1%
102.9	1	< 0.1%
87.448	1	< 0.1%
87.087	1	< 0.1%
79.92	1	< 0.1%

rms
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED

Distinct	4842
Distinct (%)	0.2%
Missing	211653
Missing (%)	6.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.3152052393

Minimum	-1
Maximum	104.33
Zeros	32506
Zeros (%)	1.0%
Negative	3
Negative (%)	< 0.1%
Memory size	25.0 MiB

Quantile statistics

Minimum	-1
5-th percentile	0.02
Q1	0.06
median	0.15
Q3	0.48
95-th percentile	1.1
Maximum	104.33
Range	105.33
Interquartile range (IQR)	0.42

Descriptive statistics

Standard deviation	0.3999009455
Coefficient of variation (CV)	1.268700185
Kurtosis	3866.23352
Mean	0.3152052393
Median Absolute Deviation (MAD)	0.11
Skewness	23.86159713
Sum	964881.3773
Variance	0.1599207662
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.03	132882	4.1%
0.02	129834	4.0%
0.04	125220	3.8%
0.05	114615	3.5%
0.01	109658	3.4%
0.06	102436	3.1%
0.07	83660	2.6%
0.08	65875	2.0%
0.09	55662	1.7%
0.1	53451	1.6%
Other values (4832)	2087828	63.8%
(Missing)	211653	6.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	3	< 0.1%
0	32506	1.0%
0.0001	135	< 0.1%
0.0002	82	< 0.1%
0.0003	77	< 0.1%
0.0004	67	< 0.1%
0.0005	60	< 0.1%
0.0006	59	< 0.1%
0.0007	53	< 0.1%
0.0008	54	< 0.1%

Value	Count	Frequency (%)
104.33	1	< 0.1%
88.39	1	< 0.1%
71.45	1	< 0.1%
69.32	1	< 0.1%
64.29	1	< 0.1%
54.64	1	< 0.1%
53.97	1	< 0.1%
50.5	1	< 0.1%
44.51	1	< 0.1%
44.08	1	< 0.1%

net
Categorical

HIGH CORRELATION

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.0 MiB

nc	893352
us	742356
ci	687371
ak	468147
nn	188158
Other values (15)	293390

Length

Max length	10
Median length	2
Mean length	2.010014746
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	ci
2nd row	ci
3rd row	ci
4th row	ci
5th row	ci

Common Values

Value	Count	Frequency (%)
nc	893352	27.3%
us	742356	22.7%
ci	687371	21.0%
ak	468147	14.3%
nn	188158	5.7%
uw	117553	3.6%
uu	97105	3.0%
hv	24196	0.7%
pr	19491	0.6%
mb	11176	0.3%
Other values (10)	23869	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nc	893352	27.3%
us	742356	22.7%
ci	687371	21.0%
ak	468147	14.3%
nn	188158	5.7%
uw	117553	3.6%
uu	97105	3.0%
hv	24196	0.7%
pr	19491	0.6%
mb	11176	0.3%
Other values (10)	23869	0.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	3256955
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Memory size	25.0 MiB

ci15471369	2
ci117296	2
usp0002reb	2
nc1136373	2
nc10084145	2
Other values (3256950)	3272764

Length

Max length	28
Median length	10
Mean length	9.831384935
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3241136 ?
Unique (%)	99.0%

Sample

1st row	ci37038459
2nd row	ci11092098
3rd row	ci15086796
4th row	ci14891508
5th row	ci10925125

Common Values

Value	Count	Frequency (%)
ci15471369	2	< 0.1%
ci117296	2	< 0.1%
usp0002reb	2	< 0.1%
nc1136373	2	< 0.1%
nc10084145	2	< 0.1%
nc10084147	2	< 0.1%
nc1136374	2	< 0.1%
usp0002rec	2	< 0.1%
usp0002red	2	< 0.1%
usp0002ree	2	< 0.1%
Other values (3256945)	3272754	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ci15471369	2	< 0.1%
nc21442644	2	< 0.1%
ak0052rhz392	2	< 0.1%
usp000dha6	2	< 0.1%
nc21442636	2	< 0.1%
uw10642283	2	< 0.1%
ak0052rj9oda	2	< 0.1%
nc69025352	2	< 0.1%
ak0052rjr4uv	2	< 0.1%
ak0052rkdx7a	2	< 0.1%
Other values (3256945)	3272754	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

updated
Categorical

HIGH CARDINALITY

Distinct	3124771
Distinct (%)	95.5%
Missing	0
Missing (%)	0.0%
Memory size	25.0 MiB

2018-06-04T20:43:45.000Z	434
2015-05-13T18:53:08.000Z	244
2015-05-13T18:53:10.000Z	241
2015-05-13T18:53:07.000Z	241
2015-05-13T18:53:06.000Z	230
Other values (3124766)	3271384

Length

Max length	24
Median length	24
Mean length	24
Min length	24

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3097344 ?
Unique (%)	94.6%

Sample

1st row	2016-04-02T20:22:05.312Z
2nd row	2016-01-29T01:43:14.870Z
3rd row	2016-04-02T17:20:31.235Z
4th row	2016-04-02T14:10:48.389Z
5th row	2016-04-02T04:32:22.103Z

Common Values

Value	Count	Frequency (%)
2018-06-04T20:43:45.000Z	434	< 0.1%
2015-05-13T18:53:08.000Z	244	< 0.1%
2015-05-13T18:53:10.000Z	241	< 0.1%
2015-05-13T18:53:07.000Z	241	< 0.1%
2015-05-13T18:53:06.000Z	230	< 0.1%
2015-05-13T18:53:11.000Z	229	< 0.1%
2015-05-13T18:53:04.000Z	227	< 0.1%
2015-05-13T18:53:05.000Z	220	< 0.1%
2015-05-13T18:53:09.000Z	211	< 0.1%
2015-05-13T18:53:12.000Z	190	< 0.1%
Other values (3124761)	3270307	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-06-04t20:43:45.000z	434	< 0.1%
2015-05-13t18:53:08.000z	244	< 0.1%
2015-05-13t18:53:10.000z	241	< 0.1%
2015-05-13t18:53:07.000z	241	< 0.1%
2015-05-13t18:53:06.000z	230	< 0.1%
2015-05-13t18:53:11.000z	229	< 0.1%
2015-05-13t18:53:04.000z	227	< 0.1%
2015-05-13t18:53:05.000z	220	< 0.1%
2015-05-13t18:53:09.000z	211	< 0.1%
2015-05-13t18:53:12.000z	190	< 0.1%
Other values (3124761)	3270307	99.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

place
Categorical

HIGH CARDINALITY

Distinct	205436
Distinct (%)	6.3%
Missing	11
Missing (%)	< 0.1%
Memory size	25.0 MiB

Northern California	356578
Central California	277140
Central Alaska	119754
Nevada	102096
Long Valley area, California	88181
Other values (205431)	2329014

Length

Max length	85
Median length	23
Mean length	23.1504475
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	116913 ?
Unique (%)	3.6%

Sample

1st row	29km NE of Independence, CA
2nd row	11km SSW of Lake Nacimiento, CA
3rd row	4km S of La Canada Flintridge, CA
4th row	9km S of Cabazon, CA
5th row	5km SE of Niland, CA

Common Values

Value	Count	Frequency (%)
Northern California	356578	10.9%
Central California	277140	8.5%
Central Alaska	119754	3.7%
Nevada	102096	3.1%
Long Valley area, California	88181	2.7%
Southern Alaska	73156	2.2%
Utah	42467	1.3%
Washington	40075	1.2%
San Francisco Bay area, California	28558	0.9%
Mount St. Helens area, Washington	28209	0.9%
Other values (205426)	2116549	64.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
of	1416287	11.5%
california	1124265	9.1%
alaska	529172	4.3%
ca	449325	3.7%
northern	414497	3.4%
central	411498	3.3%
islands	209457	1.7%
area	160219	1.3%
valley	152568	1.2%
region	151823	1.2%
Other values (9694)	7276540	59.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

type
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.0 MiB

earthquake	3184269
quarry blast	60898
explosion	20133
ice quake	3951
mining explosion	1240
Other values (20)	2283

Length

Max length	26
Median length	10
Mean length	10.03489425
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	sonic boom
2nd row	earthquake
3rd row	earthquake
4th row	sonic boom
5th row	sonic boom

Common Values

Value	Count	Frequency (%)
earthquake	3184269	97.3%
quarry blast	60898	1.9%
explosion	20133	0.6%
ice quake	3951	0.1%
mining explosion	1240	< 0.1%
nuclear explosion	738	< 0.1%
other event	517	< 0.1%
chemical explosion	392	< 0.1%
sonic boom	351	< 0.1%
rock burst	180	< 0.1%
Other values (15)	105	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
earthquake	3184269	95.3%
quarry	60915	1.8%
blast	60898	1.8%
explosion	22508	0.7%
ice	3951	0.1%
quake	3951	0.1%
mining	1240	< 0.1%
nuclear	738	< 0.1%
event	518	< 0.1%
other	517	< 0.1%
Other values (24)	1603	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

horizontalError
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	8725
Distinct (%)	0.5%
Missing	1531963
Missing (%)	46.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.266841139

Minimum	0
Maximum	280.6
Zeros	30
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	25.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0.16
Q1	0.3
median	0.48
Q3	0.93
95-th percentile	5.85
Maximum	280.6
Range	280.6
Interquartile range (IQR)	0.63

Descriptive statistics

Standard deviation	3.168282045
Coefficient of variation (CV)	2.500930817
Kurtosis	421.7268834
Mean	1.266841139
Median Absolute Deviation (MAD)	0.23
Skewness	15.20937124
Sum	2205330.991
Variance	10.03801112
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3	46545	1.4%
0.2	40313	1.2%
0.4	37721	1.2%
0.5	27889	0.9%
0.26	25706	0.8%
0.27	25643	0.8%
0.25	25527	0.8%
0.28	25332	0.8%
0.29	25312	0.8%
0.24	24808	0.8%
Other values (8715)	1436015	43.9%
(Missing)	1531963	46.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	30	< 0.1%
0.014	3426	0.1%
0.022	1360	< 0.1%
0.028	1642	0.1%
0.032	204	< 0.1%
0.036	1234	< 0.1%
0.041	77	< 0.1%
0.042	852	< 0.1%
0.045	387	< 0.1%
0.05	893	< 0.1%

Value	Count	Frequency (%)
280.6	1	< 0.1%
194.5841	1	< 0.1%
131.8	1	< 0.1%
114.231	1	< 0.1%
109.9	1	< 0.1%
103.535	1	< 0.1%
103.214	1	< 0.1%
102.579	1	< 0.1%
100.913	1	< 0.1%
99.971	1	< 0.1%

depthError
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	26851
Distinct (%)	1.0%
Missing	606685
Missing (%)	18.5%
Infinite	0
Infinite (%)	0.0%
Mean	5.640319809

Minimum	-1
Maximum	1773552.5
Zeros	68134
Zeros (%)	2.1%
Negative	3
Negative (%)	< 0.1%
Memory size	25.0 MiB

Quantile statistics

Minimum	-1
5-th percentile	0.1
Q1	0.49
median	0.96
Q3	2.76
95-th percentile	18
Maximum	1773552.5
Range	1773553.5
Interquartile range (IQR)	2.27

Descriptive statistics

Standard deviation	1167.801181
Coefficient of variation (CV)	207.0452067
Kurtosis	2008980.549
Mean	5.640319809
Median Absolute Deviation (MAD)	0.65
Skewness	1354.147975
Sum	15037594.6
Variance	1363759.597
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	68134	2.1%
31.61	61773	1.9%
0.3	57859	1.8%
0.2	56341	1.7%
0.4	52905	1.6%
0.1	50868	1.6%
0.5	46286	1.4%
0.6	39211	1.2%
0.7	32668	1.0%
0.8	27205	0.8%
Other values (26841)	2172839	66.4%
(Missing)	606685	18.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	3	< 0.1%
0	68134	2.1%
0.001	87	< 0.1%
0.002	57	< 0.1%
0.003	403	< 0.1%
0.004	185	< 0.1%
0.005	176	< 0.1%
0.006	214	< 0.1%
0.007	226	< 0.1%
0.008	219	< 0.1%

Value	Count	Frequency (%)
1773552.5	1	< 0.1%
456553.8	1	< 0.1%
367558.1	1	< 0.1%
263163.6	1	< 0.1%
148928.8	1	< 0.1%
143094.4	1	< 0.1%
104046.3	1	< 0.1%
58249.3	1	< 0.1%
37882.7	1	< 0.1%
36544.4	1	< 0.1%

magError
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	2304
Distinct (%)	0.2%
Missing	1781012
Missing (%)	54.4%
Infinite	0
Infinite (%)	0.0%
Mean	0.1668926841

Minimum	0
Maximum	6.11
Zeros	35432
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	25.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0.029
Q1	0.09
median	0.142
Q3	0.21
95-th percentile	0.38
Maximum	6.11
Range	6.11
Interquartile range (IQR)	0.12

Descriptive statistics

Standard deviation	0.1474292975
Coefficient of variation (CV)	0.8833778326
Kurtosis	200.33969
Mean	0.1668926841
Median Absolute Deviation (MAD)	0.061
Skewness	8.78860057
Sum	248964.1642
Variance	0.02173539777
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1	40759	1.2%
0.12	39202	1.2%
0.13	38825	1.2%
0.11	38164	1.2%
0.09	36845	1.1%
0.14	36448	1.1%
0.04	36331	1.1%
0	35432	1.1%
0.15	34598	1.1%
0.08	34566	1.1%
Other values (2294)	1120592	34.2%
(Missing)	1781012	54.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	35432	1.1%
0.001	253	< 0.1%
0.002	255	< 0.1%
0.003	249	< 0.1%
0.003503061067	1	< 0.1%
0.004	263	< 0.1%
0.004180668708	1	< 0.1%
0.005	264	< 0.1%
0.006	305	< 0.1%
0.007	342	< 0.1%

Value	Count	Frequency (%)
6.11	1	< 0.1%
5.99	1	< 0.1%
5.98	1	< 0.1%
5.92	1	< 0.1%
5.91	1	< 0.1%
5.9	1	< 0.1%
5.72	1	< 0.1%
5.67	1	< 0.1%
5.62	1	< 0.1%
5.61	1	< 0.1%

magNst
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	572
Distinct (%)	< 0.1%
Missing	988917
Missing (%)	30.2%
Infinite	0
Infinite (%)	0.0%
Mean	12.6073861

Minimum	0
Maximum	941
Zeros	107921
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	25.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	7
Q3	14
95-th percentile	43
Maximum	941
Range	941
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	21.12723866
Coefficient of variation (CV)	1.675782632
Kurtosis	104.7922671
Mean	12.6073861
Median Absolute Deviation (MAD)	4
Skewness	7.556319532
Sum	28793467
Variance	446.3602133
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	192369	5.9%
4	182457	5.6%
5	171848	5.3%
2	166911	5.1%
6	153345	4.7%
1	138702	4.2%
7	128834	3.9%
8	109463	3.3%
0	107921	3.3%
9	90053	2.8%
Other values (562)	841954	25.7%
(Missing)	988917	30.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	107921	3.3%
1	138702	4.2%
2	166911	5.1%
3	192369	5.9%
4	182457	5.6%
5	171848	5.3%
6	153345	4.7%
7	128834	3.9%
8	109463	3.3%
9	90053	2.8%

Value	Count	Frequency (%)
941	1	< 0.1%
854	1	< 0.1%
821	1	< 0.1%
800	1	< 0.1%
790	1	< 0.1%
774	1	< 0.1%
752	1	< 0.1%
684	1	< 0.1%
679	1	< 0.1%
667	1	< 0.1%

status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	25.0 MiB

reviewed	3133150
automatic	139611
manual	12

Length

Max length	9
Median length	8
Mean length	8.042650987
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	reviewed
2nd row	reviewed
3rd row	reviewed
4th row	reviewed
5th row	reviewed

Common Values

Value	Count	Frequency (%)
reviewed	3133150	95.7%
automatic	139611	4.3%
manual	12	< 0.1%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
reviewed	3133150	95.7%
automatic	139611	4.3%
manual	12	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

locationSource
Categorical

HIGH CARDINALITY

Distinct	199
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.0 MiB

nc	893621
ci	687375
us	561882
ak	475199
nn	188165
Other values (194)	466532

Length

Max length	10
Median length	2
Mean length	2.067562869
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	28 ?
Unique (%)	< 0.1%

Sample

1st row	ci
2nd row	ci
3rd row	ci
4th row	ci
5th row	ci

Common Values

Value	Count	Frequency (%)
nc	893621	27.3%
ci	687375	21.0%
us	561882	17.2%
ak	475199	14.5%
nn	188165	5.7%
uw	117562	3.6%
uu	97113	3.0%
hv	24253	0.7%
guc	23866	0.7%
aeic	21140	0.6%
Other values (189)	182598	5.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nc	893621	27.3%
ci	687375	21.0%
us	561882	17.2%
ak	475199	14.5%
nn	188165	5.7%
uw	117562	3.6%
uu	97113	3.0%
hv	24253	0.7%
guc	23866	0.7%
aeic	21140	0.6%
Other values (189)	182598	5.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

magSource
Categorical

HIGH CARDINALITY

Distinct	333
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	25.0 MiB

nc	894014
ci	687379
us	480643
ak	476650
nn	188176
Other values (328)	545912

Length

Max length	10
Median length	2
Mean length	2.094228932
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	83 ?
Unique (%)	< 0.1%

Sample

1st row	ci
2nd row	ci
3rd row	ci
4th row	ci
5th row	ci

Common Values

Value	Count	Frequency (%)
nc	894014	27.3%
ci	687379	21.0%
us	480643	14.7%
ak	476650	14.6%
nn	188176	5.7%
uw	117570	3.6%
uu	97117	3.0%
ath	25601	0.8%
hv	24258	0.7%
guc	20898	0.6%
Other values (323)	260468	8.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nc	894014	27.3%
ci	687379	21.0%
us	480643	14.7%
ak	476650	14.6%
nn	188176	5.7%
uw	117570	3.6%
uu	97117	3.0%
ath	25601	0.8%
hv	24258	0.7%
guc	20898	0.6%
Other values (320)	260468	8.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Unnamed: 0	time	latitude	longitude	depth	mag	magType	nst	gap	dmin	rms	net	id	updated	place	type	horizontalError	depthError	magError	magNst	status	locationSource	magSource
0	988481	1970-01-01T00:00:00.0Z	37.003502	-117.996834	0.00	0.00	mh	0.0	NaN	NaN	NaN	ci	ci37038459	2016-04-02T20:22:05.312Z	29km NE of Independence, CA	sonic boom	NaN	NaN	NaN	0.0	reviewed	ci	ci
1	988480	1970-01-01T00:00:00.0Z	35.642788	-120.933601	5.00	1.99	mh	2.0	NaN	NaN	NaN	ci	ci11092098	2016-01-29T01:43:14.870Z	11km SSW of Lake Nacimiento, CA	earthquake	NaN	NaN	NaN	0.0	reviewed	ci	ci
2	988478	1970-01-01T00:00:00.0Z	34.164520	-118.185036	0.00	0.00	mh	NaN	NaN	NaN	NaN	ci	ci15086796	2016-04-02T17:20:31.235Z	4km S of La Canada Flintridge, CA	earthquake	NaN	NaN	NaN	0.0	reviewed	ci	ci
3	988477	1970-01-01T00:00:00.0Z	33.836494	-116.781868	0.00	0.00	mh	NaN	NaN	NaN	NaN	ci	ci14891508	2016-04-02T14:10:48.389Z	9km S of Cabazon, CA	sonic boom	NaN	NaN	NaN	0.0	reviewed	ci	ci
4	988476	1970-01-01T00:00:00.0Z	33.208477	-115.476997	5.00	0.00	mh	NaN	NaN	NaN	NaN	ci	ci10925125	2016-04-02T04:32:22.103Z	5km SE of Niland, CA	sonic boom	NaN	NaN	NaN	0.0	reviewed	ci	ci
5	988475	1970-01-01T00:00:00.0Z	32.663559	-116.105026	0.00	0.00	mh	0.0	NaN	NaN	NaN	ci	ci15099228	2016-04-02T14:10:49.670Z	13km SW of Ocotillo, CA	sonic boom	NaN	NaN	NaN	0.0	reviewed	ci	ci
6	988479	1970-01-01T00:00:00.0Z	35.354450	-115.484894	0.00	0.50	mh	0.0	NaN	NaN	NaN	ci	ci10169902	2016-01-29T01:19:00.110Z	30km SSW of Primm, NV	quarry blast	NaN	NaN	NaN	0.0	reviewed	ci	ci
7	988474	1970-01-01T06:16:08.780Z	46.276500	-118.360000	-0.26	2.30	md	6.0	303.0	0.5200	0.14	uw	uw10836008	2016-07-24T23:40:13.450Z	Washington	earthquake	0.410	0.24	0.120	0.0	reviewed	uw	uw
8	988473	1970-01-01T06:44:28.060Z	46.332833	-118.391167	-0.26	2.60	md	6.0	299.0	0.4814	0.15	uw	uw10836013	2016-07-24T23:40:13.680Z	Washington	earthquake	0.144	0.09	0.210	0.0	reviewed	uw	uw
9	988472	1970-01-01T15:13:21.040Z	32.707167	-115.417000	6.00	2.75	mh	4.0	214.0	0.6036	0.58	ci	ci3324951	2016-01-29T01:29:00.290Z	8km NE of Mexicali, B.C., MX	earthquake	4.600	31.61	0.084	6.0	reviewed	ci	ci

Last rows

	Unnamed: 0	time	latitude	longitude	depth	mag	magType	nst	gap	dmin	rms	net	id	updated	place	type	horizontalError	depthError	magError	magNst	status	locationSource	magSource
3272764	2162045	2019-03-29T20:36:05.380Z	36.754300	-115.010500	9.30	1.30	ml	6.0	245.89	0.76700	0.28	nn	nn00681106	2019-03-29T20:37:34.766Z	38km WNW of Moapa Town, Nevada	earthquake	NaN	24.60	NaN	NaN	automatic	nn	nn
3272765	2162044	2019-03-29T20:40:12.492Z	63.048200	-150.533600	30.60	1.60	ml	NaN	NaN	NaN	1.26	ak	ak01941vft5t	2019-03-29T20:46:08.286Z	83km NNW of Talkeetna, Alaska	earthquake	NaN	1.40	NaN	NaN	automatic	ak	ak
3272766	2162043	2019-03-29T20:55:42.570Z	30.614800	131.023100	26.75	5.20	mww	NaN	65.00	2.50500	0.97	us	us2000k7dg	2019-03-29T21:13:01.040Z	13km S of Nishinoomote, Japan	earthquake	6.00	4.60	0.071	19.0	reviewed	us	us
3272767	2162042	2019-03-29T20:59:19.740Z	36.978500	-121.637497	5.18	1.81	md	17.0	85.00	0.05009	0.06	nc	nc73158250	2019-03-29T21:27:04.645Z	7km WSW of Gilroy, CA	earthquake	0.27	0.52	0.190	21.0	automatic	nc	nc
3272768	2162041	2019-03-29T21:18:45.410Z	37.219833	-121.761169	8.73	1.56	md	8.0	104.00	0.06873	0.04	nc	nc73158265	2019-03-29T21:49:02.766Z	10km SE of Seven Trees, CA	earthquake	0.41	1.40	0.190	7.0	automatic	nc	nc
3272769	2162040	2019-03-29T21:22:47.574Z	61.417200	-147.564900	13.10	1.20	ml	NaN	NaN	NaN	0.66	ak	ak01941vxgl1	2019-03-29T21:27:36.099Z	72km WNW of Valdez, Alaska	earthquake	NaN	0.40	NaN	NaN	automatic	ak	ak
3272770	2162039	2019-03-29T21:31:26.830Z	66.227700	-157.202600	0.00	1.80	ml	NaN	NaN	NaN	1.01	ak	ak01941vzces	2019-03-29T21:36:48.145Z	77km S of Kobuk, Alaska	earthquake	NaN	0.40	NaN	NaN	automatic	ak	ak
3272771	2162038	2019-03-29T21:33:07.890Z	33.234667	-116.771167	12.45	0.65	ml	19.0	54.00	0.01048	0.16	ci	ci37596602	2019-03-29T21:36:32.434Z	1km SW of Lake Henshaw, CA	earthquake	0.27	0.70	0.158	14.0	automatic	ci	ci
3272772	2162037	2019-03-29T21:41:40.340Z	62.829900	-148.766400	55.50	1.80	ml	NaN	NaN	NaN	0.51	ak	ak01941w1iml	2019-03-29T21:46:40.652Z	63km S of Cantwell, Alaska	earthquake	NaN	1.60	NaN	NaN	automatic	ak	ak
3272773	2162036	2019-03-29T21:47:56.920Z	33.036333	-116.436000	5.48	1.19	ml	39.0	66.00	0.14280	0.23	ci	ci37596642	2019-03-29T21:51:39.630Z	16km ESE of Julian, CA	earthquake	0.33	1.64	0.142	28.0	automatic	ci	ci

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category